
/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/car_app_export?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_search_daily_summary_d \
--export-dir /user/spark/warehouse/car_home_warehouse/ads_search_daily_summary_d \
--update-mode allowinsert \
--update-key 'stat_date' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/car_app_export?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_search_hot_keyword_top20_d \
--export-dir /user/spark/warehouse/car_home_warehouse/ads_search_hot_keyword_top20_d \
--update-mode allowinsert \
--update-key 'stat_date,keyword' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/car_app_export?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_user_search_depth_d \
--export-dir /user/spark/warehouse/car_home_warehouse/ads_user_search_depth_d \
--update-mode allowinsert \
--update-key 'stat_date' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/car_app_export?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_user_search_time_dist_d \
--export-dir /user/spark/warehouse/car_home_warehouse/ads_user_search_time_dist_d \
--update-mode allowinsert \
--update-key 'stat_date' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/car_app_export?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_brand_search_rank_d \
--export-dir /user/spark/warehouse/car_home_warehouse/ads_brand_search_rank_d \
--update-mode allowinsert \
--update-key 'stat_date' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/car_app_export?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_price_range_search_dist_d \
--export-dir /user/spark/warehouse/car_home_warehouse/ads_price_range_search_dist_d \
--update-mode allowinsert \
--update-key 'stat_date' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/car_app_export?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_search_week_over_week_d \
--export-dir /user/spark/warehouse/car_home_warehouse/ads_search_week_over_week_d \
--update-mode allowinsert \
--update-key 'stat_date' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/car_app_export?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_hot_brand_trend_7d \
--export-dir /user/spark/warehouse/car_home_warehouse/ads_hot_brand_trend_7d \
--update-mode allowinsert \
--update-key 'brand,stat_date' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/car_app_export?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_province_search_rank_d \
--export-dir /user/spark/warehouse/car_home_warehouse/ads_province_search_rank_d \
--update-mode allowinsert \
--update-key 'stat_date,province' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/car_app_export?useUnicode=true&characterEncoding=utf-8' \
--username root \
--password 123456 \
--table ads_city_search_rank_d \
--export-dir /user/spark/warehouse/car_home_warehouse/ads_city_search_rank_d \
--update-mode allowinsert \
--update-key 'stat_date,province,city' \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1